# 导入 xlwings模块
from xlwings import *

# 启动Excel程序，但不新建工作簿
app = App(visible = True, add_book = False)

# 循环新建工作簿
for i in range(6):
    workbook = app.books.add()
    workbook.save(f"D:\\python docs\\自动化办公相关代码\\file\\test{i}.xlsx")
    workbook.close()
app.quit()
